<?php

namespace App\DataTables\Admin;

use App\Models\BookingEnquiry;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class BookingEnquiriesDataTable extends DataTable
{
    /**
     * Build the DataTable class.
     *
     * @param QueryBuilder<BookingEnquiry> $query Results from query() method.
     */
    public function dataTable(QueryBuilder $query): EloquentDataTable
    {
        return (new EloquentDataTable($query))
            ->addIndexColumn()
            ->addColumn('name', function ($row) {
                return $row->name;
            })
            ->addColumn('email', function ($row) {
                return $row->email;
            })
            ->addColumn('phone', function ($row) {
                return $row->phone;
            })
            ->addColumn('pick_up_location', function ($row) {
                return $row->pick_up_location;
            })
            ->addColumn('drop_up_location', function ($row) {
                return $row->drop_up_location;
            })
            ->addColumn('pick_up_date', function ($row) {
                return $row->pick_up_date;
            })
            ->addColumn('pick_up_time', function ($row) {
                return $row->pick_up_time;
            })
            ->addColumn('vehicle_preference', function ($row) {
                return $row->vehicle_preference;
            })
            ->addColumn('details', function ($row) {
                return $row->details;
            })
            ->editColumn('created_at', function ($row) {
                return $row->created_at
                    ? $row->created_at->timezone('Asia/Kolkata')->format('d-m-Y h:i A')
                    : '';
            })
            // ->addColumn('action', function ($row) {
            //     $buttons = '<div class="table-actions d-flex">';

            //     $buttons .= '
            //             <button type="button" data-url="' . route('admin.contacts.delete', $row->id) . '" class="btn btn-danger btn-sm delete" data-id="' . $row->id . '" title="Delete">
            //                 <i class="fa fa-trash"></i>
            //             </button>';

            //     $buttons .= '</div>';

            //     return $buttons;
            // })
            ->setRowId('id')
            ->rawColumns(['status', 'action']);
    }

    /**
     * Get the query source of dataTable.
     *
     * @return QueryBuilder<BookingEnquiry>
     */
    public function query(BookingEnquiry $model): QueryBuilder
    {
        return $model->newQuery()->orderBy("created_at", "desc");
    }

    /**
     * Optional method if you want to use the html builder.
     */
    public function html(): HtmlBuilder
    {
        return $this->builder()
                    ->setTableId('bookingenquiries-table')
                     ->setTableAttribute('class', 'table table-striped table-bordered dt-responsive nowrap jambo_table bulk_action')
                    ->columns($this->getColumns())
                    ->minifiedAjax(route('admin.booking.enquiries', [], true))
                    ->orderBy(1)
                    ->selectStyleSingle()
                    ->responsive(true)
                    ->autoWidth(false)
                    ->buttons([
                        // Button::make('excel'),
                        // Button::make('csv'),
                        // Button::make('pdf'),
                        // Button::make('print'),
                        // Button::make('reset'),
                        // Button::make('reload')
                    ]);
    }

    /**
     * Get the dataTable columns definition.
     */
    public function getColumns(): array
    {
         return [
            Column::make('DT_RowIndex')->title('S.No')->orderable(false)->searchable(false),
            Column::make('name')->title('Name'),
            Column::make('email'),
            Column::make('phone'),
            Column::make('pick_up_location'),
            Column::make('drop_up_location'),
            Column::make('pick_up_date'),
            Column::make('pick_up_time'),
            Column::make('vehicle_preference')->title('Vehicle Preference: ')->addClass('none'),
            Column::make('details')->title('Details: ')->addClass('none'),
            Column::make('created_at')->title('Created'),
            // Column::computed('action')
            //     ->exportable(false)
            //     ->printable(false)
            //     ->width(60)
            //     ->addClass('text-center all'),
        ];
    }

    /**
     * Get the filename for export.
     */
    protected function filename(): string
    {
        return 'BookingEnquiries_' . date('YmdHis');
    }
}